Show AllShow All

INTERCEPT

See Also

Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values. The intercept point is based on a best-fit regression line plotted through the known x-values and known y-values. Use the INTERCEPT function when you want to determine the value of the dependent variable when the independent variable is 0 (zero). For example, you can use the INTERCEPT function to predict a metal's electrical resistance at 0°C when your data points were taken at room temperature and higher.

Syntax

INTERCEPT(known_y's,known_x's)

Known_y's    is the dependent set of observations or data.

Known_x's    is the independent set of observations or data.

Remarks

Example

The example may be easier to understand if you copy it to a blank worksheet.

ShowHow?

 
1
2
3
4
5
6
A B
Known y Known x
2 6
3 5
9 11
1 7
8 5
Formula Description (Result)
=INTERCEPT(A2:A6, B2:B6) Point at which a line will intersect the y-axis by using the x-values and y-values above (0.0483871)